how to import mysql database using command line in ubuntu
how to import mysql database using command line in ubuntu
Read about how to import mysql database using command line in ubuntu, The latest news, videos, and discussion topics about how to import mysql database using command line in ubuntu from alibabacloud.com
This article mainly introduces someMySQL databaseOfCommand LineSome Common commands, including starting and stopping services, user logon, user management, and use of commonly used batch processing commands. Let's take a look at them.
Start and Stop
MySql: www.mysql.org
First, start and stop the mysql Service
Net stop mysql
Net start mysql
Second, log on to mysql
Mysql-u user name-p User Password
Mysql-uroot-p. After you press enter, you are prompted to enter the password, enter 12345,
From: http://www.linuxidc.com/Linux/2011-01/31263.htm
I. Prepare the development environment1. install linux first. Ubuntu is used here.10.102. Install the MySQL software package. MySQL 10.10 is included in the system repository:Sudo apt-Get
The example of this article summarizes the various operation commands used by MySQL. Share to everyone for your reference, specific as follows:
MySQL installation directory
Database directory
/var/lib/mysql/
Configuration file
/usr/share/mysql (
When using MySQL DATA, you will always encounter Import and Export situations. Therefore, it is very important to correctly import and export data! The following method is used in the work:
When using MySQL DATA, you will always encounter Import and
Share Mysql commands,
1. Connect to Mysql
Format: mysql-h host address-u user name-p User Password
1. Connect to MYSQL on the local machine.
First, open the DOS window, enter the mysql \ bin directory, type the mysql-u root-p command, and press
MySQL Database Import and Export
When using MySQL DATA, you will always encounter Import and Export situations. Therefore, it is very important to correctly import and export data! The following method is used in the work:
Import:
Import data
MySQL installation directoryDatabase directory:/var/lib/mysql/Configuration file:/usr/share/mysql (mysql.server command and configuration file)Related commands:/usr/bin (mysqladmin mysqldump, etc. order)Startup script:/etc/init.d/mysql (Directory of
Dark visitor
1. Compile previous conditions
Check whether the following software has been installed. Some of them may not be necessary, but we recommend that you install them all.
Apt-get install autoconf automake autotools-dev cpp curl gawk gcc
All of the Python code in this tutorial can be obtained from Ipython notebook on the web.
Consider using plotly in your company? You can take a look at Plotly's On-premises Enterprise Edition. (Note: On-premises refers to the software running in
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.